package com.sz.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sz.pojo.Plan;
import com.sz.pojo.RevExp;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface IPlanDao extends BaseMapper<RevExp> {
    @Select("select * from ffms.plan where id=#{id}")
    Plan getPlanById(int id);

    @Update("update ffms.plan set thisyear = #{planContent} where id=#{year}")
    int modifyThisyear(String planContent,int year);

    @Update("update ffms.plan set nextyear = #{planContent} where id=#{year}")
    int modifyNextyear(String planContent,int year);
}
